IF  EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[cms_sp_Content_Delete]') AND type in (N'P', N'PC'))
DROP PROCEDURE [dbo].[cms_sp_Content_Delete]
GO

create procedure [dbo].[cms_sp_Content_Delete]
(
	@Id int
)
as
begin
	declare @publicId int
	select @publicId=PublicContentId from Contents
	where ContentId = @Id
	delete from Contents where PublicContentId = @publicId
end
GO


